Relatório - Pandas Profiling

Dataset statistics

Number of variables	14
Number of observations	4375
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	2
Duplicate rows (%)	< 0.1%
Total size in memory	478.6 KiB
Average record size in memory	112.0 B

Variable types

NUM	9
BOOL	4
CAT	1

Warnings

Dataset has 2 (< 0.1%) duplicate rows	Duplicates
`Seniority` has 520 (11.9%) zeros	Zeros
`Income` has 336 (7.7%) zeros	Zeros
`Assets` has 1619 (37.0%) zeros	Zeros
`Debt` has 3610 (82.5%) zeros	Zeros

Reproduction

Analysis started	2020-09-27 14:11:42.588150
Analysis finished	2020-09-27 14:12:14.726736
Duration	32.14 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

Seniority
Real number (ℝ_≥0)

ZEROS

Distinct	47
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.985142857
Minimum	0
Maximum	48
Zeros	520
Zeros (%)	11.9%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	12
95-th percentile	25
Maximum	48
Range	48
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.17392156
Coefficient of variation (CV)	1.023641243
Kurtosis	1.847950231
Mean	7.985142857
Median Absolute Deviation (MAD)	4
Skewness	1.388399248
Sum	34935
Variance	66.81299366
Monotocity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	520	11.9%
1	504	11.5%
2	448	10.2%
3	328	7.5%
5	261	6.0%
10	230	5.3%
4	230	5.3%
6	179	4.1%
8	161	3.7%
15	154	3.5%
Other values (37)	1360	31.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	520	11.9%
1	504	11.5%
2	448	10.2%
3	328	7.5%
4	230	5.3%

Value	Count	Frequency (%)
48	1	< 0.1%
47	1	< 0.1%
45	3	0.1%
43	2	< 0.1%
42	1	< 0.1%

Home
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	34.2 KiB

1	2311
0	2064

Common Values
Chart

Value	Count	Frequency (%)
1	2311	52.8%
0	2064	47.2%

Time
Real number (ℝ_≥0)

Distinct	11
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	46.51885714
Minimum	6
Maximum	72
Zeros	0
Zeros (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	6
5-th percentile	18
Q1	36
median	48
Q3	60
95-th percentile	60
Maximum	72
Range	66
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	14.61928212
Coefficient of variation (CV)	0.3142657197
Kurtosis	-0.4207283847
Mean	46.51885714
Median Absolute Deviation (MAD)	12
Skewness	-0.7752061897
Sum	203520
Variance	213.7234098
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
60	1907	43.6%
36	926	21.2%
48	843	19.3%
24	338	7.7%
12	146	3.3%
18	89	2.0%
30	48	1.1%
6	31	0.7%
42	29	0.7%
54	17	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	31	0.7%
12	146	3.3%
18	89	2.0%
24	338	7.7%
30	48	1.1%

Value	Count	Frequency (%)
72	1	< 0.1%
60	1907	43.6%
54	17	0.4%
48	843	19.3%
42	29	0.7%

Age
Real number (ℝ_≥0)

Distinct	50
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	37.02171429
Minimum	18
Maximum	68
Zeros	0
Zeros (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	18
5-th percentile	22
Q1	28
median	36
Q3	45
95-th percentile	57
Maximum	68
Range	50
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	10.97318652
Coefficient of variation (CV)	0.2963986604
Kurtosis	-0.6069935264
Mean	37.02171429
Median Absolute Deviation (MAD)	8
Skewness	0.4922603619
Sum	161970
Variance	120.4108224
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	176	4.0%
26	162	3.7%
32	157	3.6%
30	156	3.6%
34	154	3.5%
24	152	3.5%
27	152	3.5%
31	149	3.4%
36	143	3.3%
33	141	3.2%
Other values (40)	2833	64.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
18	8	0.2%
19	27	0.6%
20	47	1.1%
21	81	1.9%
22	111	2.5%

Value	Count	Frequency (%)
68	2	< 0.1%
66	9	0.2%
65	12	0.3%
64	13	0.3%
63	22	0.5%

Marital
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	34.2 KiB

0	3189
1	1186

Common Values
Chart

Value	Count	Frequency (%)
0	3189	72.9%
1	1186	27.1%

Records
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	34.2 KiB

1	3622
2	753

Frequencies
Length

Value	Count	Frequency (%)
1	3622	82.8%
2	753	17.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Job
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	34.2 KiB

0	2782
1	1593

Common Values
Chart

Value	Count	Frequency (%)
0	2782	63.6%
1	1593	36.4%

Expenses
Real number (ℝ_≥0)

Distinct	93
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	55.5952
Minimum	35
Maximum	173
Zeros	0
Zeros (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	35
5-th percentile	35
Q1	35
median	51
Q3	72
95-th percentile	90
Maximum	173
Range	138
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	19.45156894
Coefficient of variation (CV)	0.3498785676
Kurtosis	1.087861206
Mean	55.5952
Median Absolute Deviation (MAD)	16
Skewness	0.9665142304
Sum	243229
Variance	378.3635343
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35	1188	27.2%
45	806	18.4%
60	772	17.6%
75	559	12.8%
90	190	4.3%
105	40	0.9%
47	28	0.6%
54	27	0.6%
46	25	0.6%
42	23	0.5%
Other values (83)	717	16.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
35	1188	27.2%
37	1	< 0.1%
38	2	< 0.1%
39	4	0.1%
40	4	0.1%

Value	Count	Frequency (%)
173	1	< 0.1%
168	1	< 0.1%
165	1	< 0.1%
153	1	< 0.1%
150	1	< 0.1%

Income
Real number (ℝ_≥0)

ZEROS

Distinct	350
Distinct (%)	8.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	130.8489143
Minimum	0
Maximum	959
Zeros	336
Zeros (%)	7.7%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	80
median	120
Q3	165
95-th percentile	280
Maximum	959
Range	959
Interquartile range (IQR)	85

Descriptive statistics

Standard deviation	86.19951805
Coefficient of variation (CV)	0.6587713663
Kurtosis	10.22090803
Mean	130.8489143
Median Absolute Deviation (MAD)	40
Skewness	2.01985208
Sum	572464
Variance	7430.356912
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	336	7.7%
100	152	3.5%
150	113	2.6%
120	107	2.4%
80	87	2.0%
110	85	1.9%
90	83	1.9%
200	76	1.7%
140	75	1.7%
125	74	1.7%
Other values (340)	3187	72.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	336	7.7%
6	1	< 0.1%
8	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%

Value	Count	Frequency (%)
959	1	< 0.1%
905	1	< 0.1%
857	1	< 0.1%
830	1	< 0.1%
800	1	< 0.1%

Assets
Real number (ℝ_≥0)

ZEROS

Distinct	158
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5298.431314
Minimum	0
Maximum	250000
Zeros	1619
Zeros (%)	37.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3000
Q3	6000
95-th percentile	18000
Maximum	250000
Range	250000
Interquartile range (IQR)	6000

Descriptive statistics

Standard deviation	10582.37737
Coefficient of variation (CV)	1.997266122
Kurtosis	122.1639461
Mean	5298.431314
Median Absolute Deviation (MAD)	3000
Skewness	8.359312289
Sum	23180637
Variance	111986710.7
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1619	37.0%
4000	342	7.8%
5000	281	6.4%
3000	270	6.2%
3500	192	4.4%
6000	174	4.0%
8000	131	3.0%
10000	118	2.7%
7000	115	2.6%
2500	110	2.5%
Other values (148)	1023	23.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1619	37.0%
18	1	< 0.1%
300	1	< 0.1%
450	1	< 0.1%
500	6	0.1%

Value	Count	Frequency (%)
250000	1	< 0.1%
200000	1	< 0.1%
150000	1	< 0.1%
120000	1	< 0.1%
110000	1	< 0.1%

Debt
Real number (ℝ_≥0)

ZEROS

Distinct	181
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	342.5515429
Minimum	0
Maximum	30000
Zeros	3610
Zeros (%)	82.5%
Memory size	34.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2500
Maximum	30000
Range	30000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1217.6228
Coefficient of variation (CV)	3.554568138
Kurtosis	150.7841378
Mean	342.5515429
Median Absolute Deviation (MAD)	0
Skewness	9.199789288
Sum	1498663
Variance	1482605.283
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3610	82.5%
2000	59	1.3%
1500	51	1.2%
3000	45	1.0%
1000	39	0.9%
2500	26	0.6%
500	25	0.6%
400	20	0.5%
4000	20	0.5%
200	20	0.5%
Other values (171)	460	10.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3610	82.5%
1	2	< 0.1%
10	1	< 0.1%
12	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
30000	1	< 0.1%
23500	1	< 0.1%
21400	1	< 0.1%
15500	1	< 0.1%
15000	1	< 0.1%

Amount
Real number (ℝ_≥0)

Distinct	282
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1037.463771
Minimum	100
Maximum	4500
Zeros	0
Zeros (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	100
5-th percentile	350
Q1	700
median	1000
Q3	1300
95-th percentile	1800
Maximum	4500
Range	4400
Interquartile range (IQR)	600

Descriptive statistics

Standard deviation	469.7535311
Coefficient of variation (CV)	0.4527902988
Kurtosis	3.51701542
Mean	1037.463771
Median Absolute Deviation (MAD)	300
Skewness	1.022272339
Sum	4538904
Variance	220668.38
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000	534	12.2%
800	217	5.0%
1200	215	4.9%
1100	209	4.8%
900	196	4.5%
1300	194	4.4%
1500	193	4.4%
600	184	4.2%
500	180	4.1%
700	168	3.8%
Other values (272)	2085	47.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
100	5	0.1%
105	1	< 0.1%
107	1	< 0.1%
120	1	< 0.1%
125	3	0.1%

Value	Count	Frequency (%)
4500	1	< 0.1%
4000	3	0.1%
3900	1	< 0.1%
3875	1	< 0.1%
3800	2	< 0.1%

Price
Real number (ℝ_≥0)

Distinct	1403
Distinct (%)	32.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1459.732343
Minimum	105
Maximum	11140
Zeros	0
Zeros (%)	0.0%
Memory size	34.2 KiB

Quantile statistics

Minimum	105
5-th percentile	600
Q1	1116.5
median	1400
Q3	1688
95-th percentile	2432.3
Maximum	11140
Range	11035
Interquartile range (IQR)	571.5

Descriptive statistics

Standard deviation	621.7759951
Coefficient of variation (CV)	0.4259520577
Kurtosis	26.4458555
Mean	1459.732343
Median Absolute Deviation (MAD)	286
Skewness	2.945035832
Sum	6386329
Variance	386605.3881
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1500	46	1.1%
1200	45	1.0%
1300	45	1.0%
1600	43	1.0%
1100	38	0.9%
1700	38	0.9%
1400	35	0.8%
1350	31	0.7%
950	31	0.7%
800	29	0.7%
Other values (1393)	3994	91.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
105	1	< 0.1%
125	2	< 0.1%
175	1	< 0.1%
200	1	< 0.1%
225	1	< 0.1%

Value	Count	Frequency (%)
11140	1	< 0.1%
8800	1	< 0.1%
6900	1	< 0.1%
6802	1	< 0.1%
6700	1	< 0.1%

Status
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	34.2 KiB

1	3159
0	1216

Common Values
Chart

Value	Count	Frequency (%)
1	3159	72.2%
0	1216	27.8%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	Seniority	Home	Time	Age	Marital	Records	Job	Expenses	Income	Assets	Amount	Price	Status
0	9.0	1.0	60.0	30.0	0.0	1.0	1.0	73.0	129.0	0.0	800.0	846.0	1
1	17.0	1.0	60.0	58.0	1.0	1.0	0.0	48.0	131.0	0.0	1000.0	1658.0	1
2	10.0	0.0	36.0	46.0	0.0	2.0	1.0	90.0	200.0	3000.0	2000.0	2985.0	0
3	0.0	1.0	60.0	24.0	1.0	1.0	0.0	63.0	182.0	2500.0	900.0	1325.0	1
4	0.0	1.0	36.0	26.0	1.0	1.0	0.0	46.0	107.0	0.0	310.0	910.0	1
5	1.0	0.0	60.0	36.0	0.0	1.0	0.0	75.0	214.0	3500.0	650.0	1645.0	1
6	29.0	0.0	60.0	44.0	0.0	1.0	0.0	75.0	125.0	10000.0	1600.0	1800.0	1
7	9.0	1.0	12.0	27.0	1.0	1.0	0.0	35.0	80.0	0.0	200.0	1093.0	1
8	0.0	0.0	60.0	32.0	0.0	1.0	1.0	90.0	107.0	15000.0	1200.0	1957.0	1
9	0.0	1.0	48.0	41.0	0.0	1.0	1.0	90.0	80.0	0.0	1200.0	1468.0	0

Last rows

	Seniority	Home	Time	Age	Marital	Records	Job	Expenses	Income	Assets	Debt	Amount	Price	Status
4365	1.0	0.0	60.0	31.0	1.0	2.0	0.0	35.0	242.0	9000.0	0.0	1500.0	1656.0	1
4366	6.0	1.0	60.0	22.0	1.0	2.0	0.0	35.0	100.0	0.0	0.0	1200.0	1496.0	0
4367	6.0	0.0	48.0	52.0	0.0	1.0	0.0	45.0	190.0	3500.0	0.0	1500.0	1905.0	1
4368	3.0	0.0	60.0	49.0	0.0	1.0	0.0	35.0	160.0	3000.0	0.0	900.0	975.0	1
4369	1.0	1.0	48.0	30.0	0.0	2.0	1.0	75.0	77.0	0.0	0.0	1200.0	1300.0	0
4370	1.0	1.0	60.0	39.0	0.0	1.0	0.0	69.0	92.0	0.0	0.0	900.0	1020.0	0
4371	22.0	0.0	60.0	46.0	0.0	1.0	0.0	60.0	75.0	3000.0	600.0	950.0	1263.0	1
4372	0.0	0.0	24.0	37.0	0.0	1.0	1.0	60.0	90.0	3500.0	0.0	500.0	963.0	0
4373	0.0	1.0	48.0	23.0	1.0	1.0	1.0	49.0	140.0	0.0	0.0	550.0	550.0	1
4374	5.0	0.0	60.0	32.0	0.0	1.0	1.0	60.0	140.0	4000.0	1000.0	1350.0	1650.0	1

Most frequent

	Seniority	Home	Time	Age	Marital	Records	Job	Expenses	Income	Assets	Debt	Amount	Price	Status	count
0	4.0	0.0	60.0	37.0	0.0	1.0	1.0	35.0	128.0	18000.0	0.0	800.0	1560.0	1	2
1	5.0	0.0	60.0	36.0	0.0	1.0	1.0	90.0	62.0	3000.0	0.0	650.0	1295.0	0	2

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent